pages.app 6.0 formula glitch

Question

Level 1

22 points

pages.app 6.0 formula glitch

For years I have been using a pages.app document to do a spreadsheat for my business. Column A is a client's name, column b has the amount of the transaction, column c adds the number from column b to all the previous transactions and gives me a total for the month. Each row will have a different number for column as numbers get added to sequential rows in column b.

Now with pages.app 6.0 the number in column is added but not continued to the next row. Anyone have an idea as to how I can fix this?

Mac Pro, Mac OS X (10.6.3)

Posted on Sep 26, 2016 1:18 PM

Reply

Answer 1

VikingOSX

Level 10

124,016 points

Sep 26, 2016 3:09 PM in response to LCohen

Not without looking at your table and formulas so we can further test in Pages v6.

Reply

Answer 2

LCohen Author

Level 1

22 points

Sep 26, 2016 4:48 PM in response to VikingOSX

Here's what should happen. When client 2 is added with $500, column G goes to $1500, and etc.

Here's what is happening with version 6.0.

Column G isn't getting filled in on line 5 but on row 4 the new total is summed up.

Here's is the equation used in column g

Reply

Answer 3

VikingOSX

Level 10

124,016 points

Sep 26, 2016 5:39 PM in response to LCohen

If I am understanding the total progression, then the following formulas populate correctly:

G2

G3

G4

G5

What I see from your example is that cell G4 is set to sum(F2:F5), and I believe that formulas for G4 and G5 should be those above.

Reply

Answer 4

LCohen Author

Level 1

22 points

Sep 26, 2016 5:45 PM in response to VikingOSX

I appreciate the help. I don't understand why the new version is macossierra has glitched things up. What do I need to change about the formula?

Reply

Answer 5

VikingOSX

Level 10

124,016 points

Sep 26, 2016 6:11 PM in response to LCohen

Based on your screen shot showing the formula for cell G4, you were summing F2:F5, not F2:F4 — if I am understanding those Totals. Use my formulas for their respective G column cell and see if that clears up the Totals column.

Reply

Answer 6

LCohen Author

Level 1

22 points

Sep 27, 2016 9:10 AM in response to VikingOSX

This problem doesn't make sense. I haven't updated my MacBook to MacOS Sierra yet and my template works just fine. Now under the new OS and version 6.0 it doesn't work. Why do I need I need to change the formulas when th

Reply

Answer 7

LCohen Author

Level 1

22 points

Sep 27, 2016 9:11 AM in response to LCohen

Why do I need to change the formulas when the template I have works just fine with the previous version of pages in El Capitan?

Reply

Answer 8

VikingOSX

Level 10

124,016 points

Sep 27, 2016 5:10 PM in response to LCohen

Well, when I am signed in, I cannot see your last two posts in either Safari or Firefox.

You had selected cell G4 which would reflect Client 3 activity, and yet your formula was summing all four clients (f2:f5) to put 4400 in cell G4, instead of which I surmise it should be the summation of cells F2:F4 which would put 3500 in G4, as you have shown earlier.

That's why you should change your formula, it isn't that Pages 6 has whacked your formula, but the formula itself for cell G4 is also including Client 4 financials, which is wrong for your pattern of Total values for each client.

Reply